# -*-coding:utf-8-*-
"""
@project: python-project
@Time: 2024-07-13 9:14
@Author: Loneliness_Burial
@File: 插入数据.py
@Motto: 深情不改必坠死海
@software: pycharm
@version: python 3.7
"""

import sqlite3

conn = sqlite3.connect('D:\Desktop\LCConfigDataBase')
cursor = conn.cursor()
cursor.execute(
    'INSERT INTO login(username,password,level,roles,description,created_at,updated_at) VALUES ("admin","admin123",5,8,"测试","2024-07-13 09:00:00","2024-07-13 09:01:00")')
cursor.execute(
    'INSERT INTO login(username,password,level,roles,description,created_at,updated_at) VALUES ("user","user123",1,2,"测试","2024-07-13 09:00:00","2024-07-13 09:01:00")')
cursor.execute(
    'INSERT INTO login(username,password,level,roles,description,created_at,updated_at) VALUES ("test","test123",1,2,"测试","2024-07-13 09:00:00","2024-07-13 09:01:00")')
cursor.execute(
    'INSERT INTO login(username,password,level,roles,description,created_at,updated_at) VALUES ("abcc","abcc123",1,2,"测试","2024-07-13 09:00:00","2024-07-13 09:01:00")')
cursor.execute(
    'INSERT INTO login(username,password,level,roles,description,created_at,updated_at) VALUES ("abcd","abcd123",1,2,"测试","2024-07-13 09:00:00","2024-07-13 09:01:00")')
cursor.close()
conn.commit()
conn.close()
